1 using System;
2 using System.Collections.Generic;
3 using System.ComponentModel;
4 using System.Drawing;
5 using System.Data;
6 using System.Linq;
7 using System.Text;
8 using System.Threading.Tasks;
9 using System.Windows.Forms;
10 using System.Data.SqlClient;
11
12 namespace SoftQuanLyNhaHang.Models
13 {
14 class BomItemMod
15 {
16
17 protected int IdBomItem { get; set; }
18 protected int IdBom { get; set; }
19 protected int IdKho { get; set; }
20 protected string ChuanMaVach { get; set; }
21 protected string TrangThai { get; set; }
22 protected int TrangThaiBh { get; set; }
23 protected string LoaiHangHoa { get; set; }
24 protected double GiaBan { get; set; }
25 protected float SoLuong { get; set; }
26 protected string TenSanPham { get; set; }
27 protected int DonViTinhId { get; set; }
28 protected string TenDonViTinh { get; set; }
29 protected DateTime NgayBanHang { get; set; }
30
31 protected string IdBomStr { get; set; }
32 protected int KhachHangId { get; set; }
33
34
35 public BomItemMod(int _IdBomItem)
36 {
37 IdBomItem = _IdBomItem;
38 }
39 public BomItemMod()
40 { }
41
42 public BomItemMod(string _LoaiHangHoa, string _ChuanMaVach)
43 {
44 LoaiHangHoa = _LoaiHangHoa;
45 ChuanMaVach = _ChuanMaVach;
46 }
47
48 public BomItemMod(int _IdBom, string _LoaiHangHoa, string _ChuanMaVach)
49 {
50 IdBom = _IdBom;
51 LoaiHangHoa = _LoaiHangHoa;
52 ChuanMaVach = _ChuanMaVach;
53 }
54
55 public BomItemMod(string _IdBomStr, string _LoaiHangHoa, int _KhachHangId, DateTime _NgayBanHang)
56 {
57 IdBomStr=_IdBomStr;
58 LoaiHangHoa = _LoaiHangHoa;
59 KhachHangId =_KhachHangId;
60 NgayBanHang = _NgayBanHang;
61 }
62
63 public BomItemMod(string _IdBomStr, string _LoaiHangHoa, int _KhachHangId, DateTime _NgayBanHang, int _TrangThaiBh)
64 {
65 IdBomStr = _IdBomStr;
66 LoaiHangHoa = _LoaiHangHoa;
67 KhachHangId = _KhachHangId;
68 NgayBanHang = _NgayBanHang;
69 TrangThaiBh = _TrangThaiBh;
70 }
71
72 public BomItemMod(int _IdBomItem, int _IdBom, string _ChuanMaVach, string _TrangThai, float _SoLuong, DateTime _NgayBanHang)
73 {
74 IdBomItem = _IdBomItem;
75 IdBom= _IdBom;
76 ChuanMaVach = _ChuanMaVach;
77 TrangThai = _TrangThai;
78 SoLuong = _SoLuong;
79 NgayBanHang = _NgayBanHang;
80 }
81
82
83
84 public BomItemMod(int _IdBomItem, int _IdBom, int _IdKho, string _ChuanMaVach, string _TrangThai, string _LoaiHangHoa, double _GiaBan, float _SoLuong, string _TenSanPham, int _DonViTinhId, string _TenDonViTinh)
85 {
86 IdBomItem = _IdBomItem;
87 IdBom=_IdBom;
88 IdKho=_IdKho;
89 ChuanMaVach=_ChuanMaVach;
90 TrangThai=_TrangThai;
91 LoaiHangHoa=_LoaiHangHoa;
92 GiaBan=_GiaBan;
93 SoLuong=_SoLuong;
94 TenSanPham=_TenSanPham;
95 DonViTinhId=_DonViTinhId;
96 TenDonViTinh = _TenDonViTinh;
97 }
98
99 public int InsertBomItem()
100 {
101 int i = 0;
102 string[] paras = new string[11] { "@IdBomItem", "@IdBom", "@IdKho", "@ChuanMaVach", "@TrangThai", "@LoaiHangHoa", "@GiaBan", "@SoLuong", "@TenSanPham", "@DonViTinhId", "@TenDonViTinh" };
103 object[] values = new object[11] {IdBomItem, IdBom, IdKho, ChuanMaVach, TrangThai, LoaiHangHoa, GiaBan, SoLuong, TenSanPham, DonViTinhId, TenDonViTinh };
104 i = Int32.Parse(Models.connection.ExcuteScalar("tbl_BomItem_Insert", CommandType.StoredProcedure, paras, values));
105 return i;
106 }
107
108 public int UpdateBomItem()
109 {
110 int i = 0;
111 string[] paras = new string[11] { "@IdBomItem", "@IdBom", "@IdKho", "@ChuanMaVach", "@TrangThai", "@LoaiHangHoa", "@GiaBan", "@SoLuong", "@TenSanPham", "@DonViTinhId", "@TenDonViTinh" };
112 object[] values = new object[11] {IdBomItem, IdBom, IdKho, ChuanMaVach, TrangThai, LoaiHangHoa, GiaBan, SoLuong, TenSanPham, DonViTinhId, TenDonViTinh };
113 i = Models.connection.Excute_Sql("tbl_BomItem_Update", CommandType.StoredProcedure, paras, values);
114 return i;
115 }
116
117 public int DeleteBomItem()
118 {
119 int i = 0;
120 string[] paras = new string[1] { "@IdBomItem"};
121 object[] values = new object[1] { IdBomItem };
122 i = Models.connection.Excute_Sql("tbl_BomItem_Delete", CommandType.StoredProcedure, paras, values);
123 return i;
124 }
125
126 //lay sản phẩm them idbom,and chuan mavach
127 public DataSet FillDataSet_getBomItem_SearchAll()
128 {
129 DataSet ds = new DataSet();
130 string[] paras = new string[11] { "@IdBomItem", "@IdBom", "@IdKho", "@ChuanMaVach", "@TrangThai", "@LoaiHangHoa", "@GiaBan", "@SoLuong", "@TenSanPham", "@DonViTinhId", "@TenDonViTinh" };
131 object[] values = new object[11] { IdBomItem, IdBom, IdKho, ChuanMaVach, TrangThai, LoaiHangHoa, GiaBan, SoLuong, TenSanPham, DonViTinhId, TenDonViTinh };
132 ds = Models.connection.FillDataSet("tbl_BomItem_SearchAll", CommandType.StoredProcedure, paras, values);
133 return ds;
134 }
135
136 //tim sản pham cho bom
137 public DataSet FillDataSet_getBomItem_ByLoaiHangHoa_ChuanMaVach()
138 {
139 DataSet ds = new DataSet();
140 string[] paras = new string[3] { "@IdBom","@LoaiHangHoa", "@ChuanMaVach"};
141 object[] values = new object[3] { IdBom,LoaiHangHoa, ChuanMaVach };
142 ds = Models.connection.FillDataSet("tbl_BomItem_ByLoaiHangHoa_ChuanMaVach", CommandType.StoredProcedure, paras, values);
143 return ds;
144 }
145
146 //lay san pham khuyen mai
147 public DataSet FillDataSet_BomItem_Get_SpKhuyenMai()
148 {
149 //int _IdBomItem, int _IdBom , string _ChuanMaVach, int _SoLuong, string _TrangThai
150 DataSet ds = new DataSet();
151 string[] paras = new string[6] { "@IdBomItem", "@IdBom", "@ChuanMaVach", "@TrangThai", "@SoLuong", "@NgayBanHang" };
152 object[] values = new object[6] { IdBomItem, IdBom, ChuanMaVach, TrangThai, SoLuong, NgayBanHang };
153 ds = Models.connection.FillDataSet("tbl_BomItem_Get_SpKhuyenMai", CommandType.StoredProcedure, paras, values);
154 return ds;
155 }
156
157 public DataSet FillDataSet_BomItem_Get_SpKhuyenMai_Count()
158 {
159 DataSet ds = new DataSet();
160 string[] paras = new string[6] { "@IdBomItem", "@IdBom", "@ChuanMaVach", "@TrangThai", "@SoLuong", "@NgayBanHang" };
161 object[] values = new object[6] { IdBomItem, IdBom, ChuanMaVach, TrangThai, SoLuong, NgayBanHang };
162 ds = Models.connection.FillDataSet("tbl_BomItem_Get_SpKhuyenMai_Count", CommandType.StoredProcedure, paras, values);
163 return ds;
164 }
165
166 //kiem tra so hang khuyen mai thuoc khach hang
167 public DataSet FillDataSet_BomItem_Get_SpKhuyenMai_KiemTra()
168 {
169 DataSet ds = new DataSet();
170 string[] paras = new string[4] {"@IdBomStr","@LoaiHangHoa","@KhachHangId","@NgayBanHang"};
171 object[] values = new object[4] {IdBomStr,LoaiHangHoa,KhachHangId,NgayBanHang};
172 ds = Models.connection.FillDataSet("tbl_BomItem_Get_SpKhuyenMai_KiemTra", CommandType.StoredProcedure, paras, values);
173 return ds;
174 }
175
176 //danh sach khuyen mai
177 public DataSet FillDataSet_BomItem_Get_SpKhuyenMai2()
178 {
179 DataSet ds = new DataSet();
180 string[] paras = new string[4] { "@IdBomStr", "@LoaiHangHoa", "@KhachHangId", "@NgayBanHang" };
181 object[] values = new object[4] { IdBomStr, LoaiHangHoa, KhachHangId, NgayBanHang };
182 ds = Models.connection.FillDataSet("tbl_BomItem_Get_SpKhuyenMai2", CommandType.StoredProcedure, paras, values);
183 return ds;
184 }
185
186 //lay cac san pham khach mua hang co trong BomItem
187 public DataSet FillDataSet_BomItem_Get_ChuanMaVach_Khach_MuaHang()
188 {
189 DataSet ds = new DataSet();
190 string[] paras = new string[4] { "@IdBomStr", "@LoaiHangHoa", "@KhachHangId", "@NgayBanHang" };
191 object[] values = new object[4] { IdBomStr, LoaiHangHoa, KhachHangId, NgayBanHang };
192 ds = Models.connection.FillDataSet("tbl_BomItem_Get_ChuanMaVach_Khach_MuaHang", CommandType.StoredProcedure, paras, values);
193 return ds;
194 }
195 }
196 }